When upgrading from iMIS Analytics 1.0 to the current release of Analytics, as described in Installing Analytics, you must manually migrate your data warehouse tables from Analytics 1.0 into the new iMIS_Analytics data warehouse that is created when you install the current release of Analytics.
Caution! Certain tables and views must not be imported from the older data warehouse. These objects are listed in the following procedure.
Before you begin
■ All Analytics system requirements for the Analytics host must be in place.
■ The following procedure must be performed on the Analytics host.
To migrate the Analytics 1.0 data warehouse to the Analytics 15.0.x data warehouse
1. Using Microsoft SQL Server Management Studio, connect to the Database Engine on the Analytics host.
2. In the Object Explorer pane, expand the Databases folder.
3. Right-click the iMIS_Analytics database and choose Tasks > Import Data.
The welcome page of the SQL Server Import and Export Wizard appears.
4. Click Next.
The Choose a Data Source page appears.
5. Using the Server name and Database fields, specify your Analytics 1.0 data warehouse, then click Next.
The Choose a Destination page appears.
6. Click Next without changing any values.
The Specify Table Copy or Query page appears.
7. Select Copy data from one or more tables or views, then click Next.
The Select Source Tables and Views page appears.
8. In the first column, select every table except for the following:
□ DWMColumn
□ DWMTable
□ DWParameters
9. Ensure that you have not selected any views in the list, then click Next.
The Save and Execute Package page appears.
10. Ensure that the Execute immediately checkbox is selected and click Finish twice to begin importing the selected tables from the old data warehouse.
The wizard displays status while it imports the tables.